| FaStudentAid_Proxy |
| Logical Entity Name | FaStudentAid_Proxy |
| Default Table Name | FaStudentAid_Proxy |
| Physical Only | NO |
| Definition | |
| Note |
| FaStudentAid_Proxy Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
FaStudentAid_ProxyID |
bigint | NO | ||
| TableName | varchar(255) | NO | ||
| RecordID | int | NO | ||
| OldStatus | char(1) | YES | ||
| NewStatus | char(1) | YES | ||
| OldAmountPackaged | money | NO | ||
| NewAmountPackaged | money | NO | ||
| Comment | varchar(400) | YES | ||
| SyStudentID | int | NO | ||
| UserID | int | NO | ||
| ModFlag | char(1) | YES | ||
| OldFaBankID | int | YES | ||
| NewFaBankID | int | YES | ||
| OldFaServicerID | int | YES | ||
| NewFaServicerID | int | YES | ||
| OldFaGuarantorID | int | YES | ||
| NewFaGuarantorID | int | YES | ||
| OldNumberPayments | int | YES | ||
| NewNumberPayments | int | YES | ||
| DateAdded | datetime | NO | ||
| OldDateLoanStart | datetime | YES | ||
| NewDateLoanStart | datetime | YES | ||
| OldDateLoanEnd | datetime | YES | ||
| NewDateLoanEnd | datetime | YES | ||
| OldLoanAcYrStartDate | datetime | YES | ||
| NewLoanAcYrStartDate | datetime | YES | ||
| OldLoanAcYrEndDate | datetime | YES | ||
| NewLoanAcYrEndDate | datetime | YES | ||
| OldFaStudentLoanPeriodID | int | YES | ||
| NewFaStudentLoanPeriodID | int | YES |
| FaStudentAid_Proxy Primary and Unique Keys |
| Key Name | Key Type | Keys |
| FaStudentAid_Proxy_FaStudentAid_ProxyID_U_C_IDX | PrimaryKey | FaStudentAid_ProxyID |
| FaStudentAid_Proxy Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| FaStudentAid_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |